Excel 2016 Bible by John Walkenbach

Author:John Walkenbach
Language: eng
Format: epub, pdf
Published: 2018-07-17T16:00:00+00:00

Figure 20.9 The Format Axis task pane for a value axis.

By default, Excel determines the minimum and maximum axis values automatically, based on the numerical range of the data. To override this automatic axis scaling, enter your own minimum and maximum values in the Bounds section. If you change these values, the word Auto changes to a Reset button. Click Reset to revert to automatic axis scaling.

Excel also adjusts the major and minor axis units automatically. Again, you can override Excel's choice and specify different units.

Adjusting the bounds of a value axis can dramatically affect the chart's appearance. Manipulating the scale, in some cases, can present a false picture of the data. Figure 20.10 shows two line charts that depict the same data. The chart on the left uses Excel's default (Auto) axis bounds values, which extend from 1,600 to 1,950. In the chart on the right, the Minimum bound value was set to 0, and the Maximum bound value was set to 3,000. The first chart makes the differences in the data seem more prominent. The second chart gives the impression that there isn't much change over time.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.